import json

import pandas as pd

# 读取Excel文件
file_path = 'D:\\工作文档\舌诊算法\\证型及风险20240507.xlsx'
df = pd.read_excel(file_path, header=0, engine='openpyxl')

# 显示前5行数据
json_data = df.to_json(orient='records', force_ascii=False)
# print(json_data)
array = json.loads(json_data)


arr = [1, 2, 3, 4, 4, 5, 6, 6, 7, 8, 9, 9]
unique_arr = list(set(arr))
print(unique_arr)
for item in array:
    print(item['code'], item['name'])
    print(item['manSymptomDesc'])
